﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_GROUPS_UP')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_GROUPS_UP
	END

GO

CREATE PROCEDURE [dbo].[PRC_TB_GROUPS_UP] 
(
    @TGID Integer,
    @TGDESCRIPTION Varchar(150),
    @TGIDENTIFICATION Varchar(80),
    @TGNAME Varchar(150) 
)
AS
	UPDATE TB_GROUPS
	SET TG_NAME = @TGNAME,
	TG_IDENTIFICATION = @TGIDENTIFICATION,
	TG_DESCRIPTION = @TGDESCRIPTION
	WHERE TG_ID = @TGID


GO

GRANT EXEC ON dbo.PRC_TB_GROUPS_UP TO PUBLIC

GO

